package com.demo.dao;

import com.demo.pojo.Developer;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @ClassName ItemDao
 * @Description TODO
 * @Author Windy
 * @Date 2022/8/25 14:32
 * @Version 1.0
 **/
public interface DeveloperDao {

    //通过did获取数据
    @Select("select * from developer where did=#{did} and status=1")
    Developer findDeveloperByDid(String did);

    @Select("select * from developer where status=1")
    List<Developer> findAll();

    //通过did获取数据
    @Select("select dname as developerName from developer where did=#{did} and status=1")
    String getNameByDid(String did);
}
